Release 10.1A: OpenEdge Data Management:
SQL Reference

SQLCursor

Allows rows of data to be retrieved from a database or another stored procedure’s result set.

Constructors

SQLCursor (String statement)

Parameters

statement

Generates a result set. Enclose the SQL statement in double quotes. The SQL statement is either a SELECT or CALL statement.

Notes

A SELECT statement queries the database and returns data that meets the criteria specified by the query expression in the SELECT statement.
A CALL statement invokes another stored procedure that returns a result set specified by the RESULT clause of the CREATE PROCEDURE statement.

Throws

DhSQLException

Examples

The following excerpt from a stored procedure instantiates an SQLCursor object called cust_cursor that retrieves data from a database table:

SQLCursor empcursor = new SQLCursor ( "SELECT name, sal FROM emp " ) ;

The following excerpt from a stored procedure instantiates an SQLCursor object called cust_cursor that calls another stored procedure:

t_cursor = new SQLCursor ( "CALL get_customers (?) ") ;